Tabela ProsectoriumEpisode

Definicja tabeli ProsectoriumEpisode

Name

ProsectoriumEpisode

Code

ProsectoriumEpisode

Comment

Informacje na temat przechowywania cial (epizodów z prosektorium)


Lista kolumn tabeli ProsectoriumEpisode

Name

Code

EpisodeID

EpisodeID

CommercialSection

CommercialSection

AdmissionNote

AdmissionNote

DischargeNote

DischargeNote

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT

SectionWithdraw

SectionWithdraw

CancelReason

CancelReason


Kolumna EpisodeID tabeli ProsectoriumEpisode

Definicja kolumny EpisodeID tabeli ProsectoriumEpisode

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CommercialSection tabeli ProsectoriumEpisode

Definicja kolumny CommercialSection tabeli ProsectoriumEpisode

Name

CommercialSection

Code

CommercialSection

Data Type

NUMBER(10)

Mandatory

No

Comment

Informacja czy bedzie wykonywana sekcja komercyjna


Kolumna AdmissionNote tabeli ProsectoriumEpisode

Definicja kolumny AdmissionNote tabeli ProsectoriumEpisode

Name

AdmissionNote

Code

AdmissionNote

Data Type

VARCHAR2(250)

Mandatory

No

Comment

Uwagi podczas przyjecia ciala


Kolumna DischargeNote tabeli ProsectoriumEpisode

Definicja kolumny DischargeNote tabeli ProsectoriumEpisode

Name

DischargeNote

Code

DischargeNote

Data Type

VARCHAR2(250)

Mandatory

No

Comment

Uwagi podczas zamykania epizodu w prosektorium


Kolumna InsertingPerson tabeli ProsectoriumEpisode

Definicja kolumny InsertingPerson tabeli ProsectoriumEpisode

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli ProsectoriumEpisode

Definicja kolumny InsertDate tabeli ProsectoriumEpisode

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna LastModifiedPerson tabeli ProsectoriumEpisode

Definicja kolumny LastModifiedPerson tabeli ProsectoriumEpisode

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli ProsectoriumEpisode

Definicja kolumny LastModifiedDT tabeli ProsectoriumEpisode

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna SectionWithdraw tabeli ProsectoriumEpisode

Definicja kolumny SectionWithdraw tabeli ProsectoriumEpisode

Name

SectionWithdraw

Code

SectionWithdraw

Data Type

NUMBER(10)

Mandatory

No

Comment

Flaga 'Odstapienie od sekcji'


Kolumna CancelReason tabeli ProsectoriumEpisode

Definicja kolumny CancelReason tabeli ProsectoriumEpisode

Name

CancelReason

Code

CancelReason

Data Type

VARCHAR2(250)

Mandatory

No

Comment

 


Lista kluczy tabeli ProsectoriumEpisode

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ProsectoriumEpisode

Definicja klucza Identifier_1 tabeli ProsectoriumEpisode

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment